BEGIN
    DBMS_SCHEDULER.CREATE_JOB (
        job_name        => 'auto_to_zcrkhc',
        job_type        => 'PLSQL_BLOCK',
        job_action      => 'BEGIN auto_create_hcd_main(); END;',  -- 调用存储过程
        start_date      => SYSTIMESTAMP,
        repeat_interval => 'FREQ=MONTHLY;BYMONTHDAY=10;BYHOUR=2;BYMINUTE=0;BYSECOND=0', -- 每个月的10号
        enabled         => TRUE
    );
END;
/



 -- 删除
BEGIN
    DBMS_SCHEDULER.DROP_JOB(
        job_name => 'auto_to_zcrkhc',
        force    => TRUE   -- 如果作业正在运行，强制删除
    );
END;
/